Rate Override
An employee or supervisor may be able to use the cell comments dialog box to overwrite the rates used in the calculation.
An employee can modify the rate if the Modify option is selected in the User-Defined Rates area of the Basic Information tab of the Timesheet Classes screen for the class to which the employee belongs.
A supervisor can modify the rate if the Modify Charges option is selected in the General Rights area of the Basic Information tab of the Functional Roles screen for the supervisor's functional role.
Once the rate is changed, click Calculate to recalculate the amount.
The TS_CELL table stores the source of the rates in the s_rate1_cd and s_rate2_cd columns. The values are:
- N - None
- C - Charge Tree
- E - Employee History
- M - Manual Entry
- 1 - Link17/Wildcard
- 2 - Link27/Wildcard
- 7 - UDT07
Examples
Here are a few examples to show how the calculations are performed. The following information represents a system's configuration:
- Employee 1
- Rate - 10.00
- Employee Fringe Reduction - 5.00
- Employee 2
- Rate - 20.00
- Employee Fringe Reduction - 9.00
- Pay Type REG
- Calculation Method - (Hours x Rate x Factor) + Fixed Amount
- Factor - 1
- Fixed Amount - 0
- Pay Type - OT
- Calculation Method - (Hours x Rate x Factor) + Fixed Amount
- Factor - 1.5
- Fixed Amount - 0
- Pay Type - REGSHFT
- Calculation Method - (Hours x Rate x Factor) + (Hours x Fixed Amount)
- Factor - 1
- Fixed Amount - .50
- Pay Type - OTSHFT
- Calculation Method - (Hours x Rate x Factor) + (Hours x Fixed Amount x Factor)
- Factor - 1.5
- Fixed Amount - .50
- Wage Schedule for Project XYZ (Certain Location, Union, and Labor Code)
- Wage Schedule Rate - 15.00
- Apply if Higher than Employee
- Fringe Rate - 12.00
| Employee | Project | Pay Type | Hours | Pay Type Calculation | Fringe Calculation | Amount |
|---|---|---|---|---|---|---|
| 1 | ABC | REG | 8 | (8 x 10 x 1) + 0 | 80.00 | |
| 1 | XYZ | REG | 8 | (8 x 15 x 1) + 0 | + (8 x 12) (8 x 5) | 176.00 |
| 1 | ABC | OT | 8 | (8 x 10 x 1.5) + 0 | 120.00 | |
| 1 | XYZ | OT | 8 | (8 x 15 x 1.5) + 0 | + (8 x 12) (8 x 5) | 236.00 |
| 1 | ABC | REGSHFT | 8 | (8 x 10 x 1) + (8 x .50) | 84.00 | |
| 1 | XYZ | REGSHFT | 8 | (8 x 10 x 1) + (8 x .50) | + (8 x 12) (8 x 5) | 180.00 |
| 1 | ABC | OTSHFT | 8 | (8 x 10 x 1.5) + (8 x .50 x 1.5) | 126.00 | |
| 1 | XYZ | OTSHFT | 8 | (8 x 15 x 1.5) + (8 x .50 x 1.5) | + (8 x 12) (8 x 5) | 242.00 |
| 2 | ABC | REG | 8 | (8 x 20 x 1) + 0 | 160.00 | |
| 2 | XYZ | REG | 8 | (8 x 20 x 1) + 0 | + (8 x 12) (8 x 9) | 184.00 |
| 2 | ABC | OT | 8 | (8 x 20 x 1.5) + 0 | 240.00 | |
| 2 | XYZ | OT | 8 | (8 x 20 x 1.5) + 0 | + (8 x 12) (8 x 9) | 264.00 |
| 2 | ABC | REGSHFT | 8 | (8 x 20 x 1) + (8 x .50) | 164.00 | |
| 2 | XYZ | REGSHFT | 8 | (8 x 20 x 1) + (8 x .50) | + (8 x 12) (8 x 9) | 188.00 |
| 2 | ABC | OTSHFT | 8 | (8 x 20 x 1.5) + (8 x .50 x 1.5) | 246.00 | |
| 2 | XYZ | OTSHFT | 8 | (8 x 20 x 1.5) + (8 x .50 x 1.5) | + (8 x 12) (8 x 9) | 270.00 |